package com.css.fxfzypg.modules.baseData.repository;

import com.css.fxfzypg.modules.baseData.entity.Elevation;
import com.css.fxfzypg.modules.baseData.queryParams.ElevationQueryParams;
import com.css.fxfzypg.modules.baseData.vo.ElevationVO;
import org.springframework.data.domain.Page;

import java.sql.Timestamp;
import java.util.List;

public interface ElevationRepository {
    ElevationVO updateElevation(ElevationVO elevationVO);
    Elevation saveElevation(Elevation elevation);
    Page<Elevation> getAllElevationParams(ElevationQueryParams queryParams);
    Elevation getElevationById(String id);
    void deleteElevationsById(List<String> ids, Timestamp timestamp);
    List<Elevation> getAll();
    void importExcel(List<Elevation> elevations);

    Integer countByCounty(String province, String city, String county);
    Integer countByCity(String province, String city);
    Integer countByProvince(String province);

    Integer countByProvinceAndYear(String provinceName, String taskYear);
}
